
CTL10.05.001
Revision 2/15/2010 A
SQL Server 2OO8
Engine Post-Installation
CRITICAL TASK LIST PROGRAM
This document contains steps that will assist you in the completion of and review of a installation of a non-clustered SQL Server 2008 RTM Enterprise Edition software Instance.
Review each item, placing a check in the “Confirmed” column when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.
This CTL is not meant to be a replacement for the official documentation from the product manufacturer.
CTL NUMBER
This Critical Task List is identified by a CTL number in the upper right-hand side of this document. You should use the latest CTL (identified by the date and an alpha-numeric code).
HOW TO BE ASSURED OF HAVING LATEST DATA
Refer here. You can also add additional information to this checklist based on your organization’s need.
CONTENT
Critical Task List 10.05.001 contains steps required to properly evaluate the post-installation steps for SQL Server 2OO8 on a new system.
All content is the sole responsibility of the server owner; Microsoft Corporate provides no warranties implied or implicit in this document. This document is not a product of the Microsoft Corporation.
SUPPLEMENTS
Official Site Link:
Whenever you receive a supplement affecting your checklist, write in the appropriate information. Printed replacement checklist pages will be made available to you as quickly as possible. A notation on the bottom inside corner of these pages will indicate that they reflect certain supplements.
COMMENTS AND QUESTIONS
Comments and questions should be added at the end of the checklist.
Critical Task Lists Managers
Buck Woody “Real World DBA”
(MSFT U.S.)
Task |
Notes |
Confirmed |
1. Restarted SQL Server. (not required, but advised) |
||
2. Checked all service states for desired configuration, using SQL Server Configuration Manager. |
||
3. Windows Update (if used) run for service-pack/hotfix detection. |
||
4. model System Database settings configured for desired global configuration. |
||
5. Database Roles created in model System Database for desired global configuration. |
||
6. Windows Accounts Granted Access as appropriate. |
||
7. SQL Server Instance and Database Accounts created as required. |
||
8. Accounts placed in appropriate Database and Server Roles. |
||
9. All security set to be audited or documented for manual audit. |
||
10.Tested connection from server and administration workstation using bcp, SQLCMD, PowerShell and SQL Server Management Studio (if installed). |
||
11.Databases Restored, where applicable. |
||
12.Full Database Maintenance set up and run, evaluated for successful completion. |
||
13.Monitoring installed and configured. |
||
14.Evaluated Remote DAC. Configured where appropriate. |
||
15.Encryption Keys set up and backed up to remote store. |
||
16.System Documentation created. |
||
17.Performance baseline created. |
Load comments